Hệ thống quản lý cửa hàng thú cưng bằng PHP

9.475 lượt xem;

deleteanimal.php
source code /
project /

1 <html>
2 <head>
3         <title>Animals </title>
4         <style>
5 body {
6   margin: 0;
7   font-family: Arial, Helvetica, sans-serif;
8   background: #484848;
9   }
10 .topnav {
11   overflow: hidden;
12   background-color: #4CAF50;
13   height: 70px;
14   border: 3px solid green;
15 }
16
17 .topnav a {
18   float: left;
19   color: #f2f2f2;
20   text-align: center;
21   padding: 14px 16px;
22   text-decoration: none;
23   font-size: 35px;
24   font-weight: bold;
25
26 }
27
28
29 </style>
30 <body>
31 <div class="topnav">
32 <a class="active" href="home.html"><img src="ic_add_pet.png"></a>
33             <a href="animals.php">Animals</a>
34           </div>
35 <?php
36
37 $servername = "localhost";
38 $username = "root";
39 $password = "";
40 $dbname = "Petshop_management";
41
42 // Create connection
43 $conn = new mysqli($servername, $username, $password, $dbname);
44 // Check connection
45 if ($conn->connect_error) {
46     die("Connection failed: " . $conn->connect_error);
47 }
48 //echo " CONNECTION ESTABLISHED \r\n";
49 //echo " INSERTION IN PROCESS";
50 $pet_id=$_POST["t1"];
51
52 $Query2="select count(*) from pets where pet_id='$pet_id'";
53 $Execute = mysqli_query($conn,$Query2);
54 $count = mysqli_fetch_row($Execute);
55
56
57 if($count[0]==1)
58 {
59
60     $sql = "DELETE FROM pets WHERE pet_id='$pet_id'";
61     if ($conn->query($sql) == TRUE) {
62         echo '<div>
63     <h1 style="color:#f2f2f2;font-size:40px; font-family: "Roboto", sans-serif;margin:auto;">Data deleted successfully</h1>
64        </div>';
65     } else {
66         echo "Error: " . $sql . "<br>" . $conn->error;
67     }
68 }
69 else{
70     echo '<div>
71     <h1 style="color:#f2f2f2;font-size:40px; font-family: "Roboto", sans-serif;margin:auto;"> Data not found</h1>
72        </div>';
73 }
74 $conn->close();
75 ?>
76 <form>
77     <button type="submit" style=" height: 50px;width: 150px;cursor:pointer;border-radius:15px;
78 border: 3px solid green;background-color: #4CAF50;color:#f2f2f2;font-size:17px;"formaction="animals.php">Back</button>
79 </form>
80 <body>
81 <html>